﻿<%@ Page Title="" Language="C#" MasterPageFile="~/masterPage.Master" AutoEventWireup="true" CodeFile="jfView.aspx.cs" Inherits="jfView" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 
        DataSourceID="SqlDataSourcejf" EnableModelValidation="True" Height="50px" 
        Width="443px">
        <Fields>
            <asp:BoundField DataField="jfID" HeaderText="机房编号" SortExpression="jfID" />
            <asp:BoundField DataField="j_Name" HeaderText="机房名" 
                SortExpression="j_Name" />
            <asp:BoundField DataField="j_address" HeaderText="机房地址" 
                SortExpression="j_address" />
            <asp:BoundField DataField="j_class" 
                SortExpression="j_class" />
            <asp:BoundField DataField="j_jsh" HeaderText="教室号" SortExpression="j_jsh" />
            <asp:BoundField DataField="j_zy" HeaderText="作用" SortExpression="j_zy" />
            <asp:BoundField DataField="j_kfsj_s" HeaderText="开放时间" 
                SortExpression="j_kfsj_s" />
            <asp:BoundField DataField="j_kfsj_e" HeaderText="关闭时间" 
                SortExpression="j_kfsj_e" />
        </Fields>
    </asp:DetailsView>
    <asp:SqlDataSource ID="SqlDataSourcejf" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LabInfoManageSystemConnectionString %>" 
        SelectCommand="SELECT * FROM [jfInfo] WHERE ([jfID] = @jfID)">
        <SelectParameters>
            <asp:QueryStringParameter Name="jfID" QueryStringField="jfID" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource><br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSourceSB" EnableModelValidation="True" Width="423px">
        <Columns>
            <asp:BoundField DataField="sbID" HeaderText="编号" SortExpression="sbID" 
                InsertVisible="False" ReadOnly="True" />
            <asp:BoundField DataField="s_class" HeaderText="s_class" 
                SortExpression="s_class" />
            <asp:BoundField DataField="s_Name" HeaderText="设备名" 
                SortExpression="s_Name" />
            <asp:BoundField DataField="s_zy" HeaderText="作用" SortExpression="s_zy" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSourceSB" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LabInfoManageSystemConnectionString %>" 
        SelectCommand="SELECT * FROM [sbInfo] WHERE ([s_jfID] = @s_jfID)">
        <SelectParameters>
            <asp:QueryStringParameter Name="s_jfID" QueryStringField="jfID" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:GridView ID="GridView2" runat="server" AllowPaging="True" 
        AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSourceys" 
        EnableModelValidation="True" Enabled="False" Visible="False" Width="437px">
        <Columns>
            <asp:BoundField DataField="zzID" HeaderText="zzID" InsertVisible="False" 
                ReadOnly="True" SortExpression="zzID" />
            <asp:BoundField DataField="ysID" HeaderText="ysID" SortExpression="ysID" />
            <asp:BoundField DataField="jfID" HeaderText="jfID" SortExpression="jfID" />
            <asp:BoundField DataField="ysdate" HeaderText="ysdate" 
                SortExpression="ysdate" />
            <asp:BoundField DataField="ysks" HeaderText="ysks" SortExpression="ysks" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSourceys" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LabInfoManageSystemConnectionString %>" 
        SelectCommand="SELECT * FROM [ysInfo] WHERE ([jfID] = @jfID)">
        <SelectParameters>
            <asp:QueryStringParameter Name="jfID" QueryStringField="jfID" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>

